Update Normalization Views Commands

System: Update Normalization Views

Note: This functionality is only available in systems licensed for FULL mode.

Update Normalization Views (NORMALIZE via script) is a system-level command that triggers the service to update the specified normalization view(s). Normalization views are utilized for data reports and exports, and configured via the Options button on the Admin menu by users with proper security access. Eligible Nodes include Station Nodes (station meters or station groups) or Liquid Device Nodes (with support for periodic history).

Note: If the optional Include Archived Data parameter is selected (set to Yes), be aware that there could be a significant impact on processing time in order to traverse associated data archives.

You must have proper security authorization to execute this command. See FMS Security (and CMDSYS security event) for information about configuring security access for FMS commands.

See Configuring Normalization Views and Running Update Normalization Views Commands for more information about using this command via FMS Explorer.

See Scheduling FMS Command Tasks in the MSS for more information about scheduling commands.

See FMS ActiveX Controls and CxHmiFms for more information about using commands via FMS ActiveX controls on CygNet Studio or CygNet Vision screens.

See CxFms for more information about scripting commands.

Managing Update Normalization Views Commands

Prior to running Update Normalization Views commands, verify or configure the normalization views that exist in your system. Normalization views are configured by users with proper security access, via the Options button on the FMS Explorer Admin menu. See Configuring Normalization Views for more information.

Command Definition Properties

The following command definition properties apply to Update Normalization Views commands, when scheduling, creating, or editing commands via CygNet Explorer.

Property	Description
FMS service	Select a Site.Service for the command from the available FMS service list in the drop-down menu.
Command	Select the desired Command name from the drop-down menu. See FMS Commands for more information about available command types.
Priority	Select a processing queue Priority for the command from the drop-down menu. Options from least to greatest priority are as follows. Low level Medium level High level User initiated transaction Admin initiated transaction Default value is Low level processing queue priority.
Logging	Select a Logging level for the command results from the drop-down menu. Options are as follows. Low — displays errors Medium — displays errors and warnings High — displays errors, warnings, and status Default value is Low level logging when scheduling a command via the MSS in CygNet Explorer. Default value is High level logging when creating or running an ad-hoc command in FMS Explorer or via the FMS in CygNet Explorer.

Command Parameters

The following command parameters apply to Update Normalization Views commands, when scheduling, creating, or editing commands via CygNet Explorer or scripting.

Note: The actual normalization view referenced by the command does not appear in this dialog box, as it is too complex to be shown in this format. Normalization views can be viewed and configured via the Options button on the FMS Explorer Admin menu by users with proper security access. See Configuring Normalization Views for more information.

Parameter	Description	Type	Usage Notes
NormView	Normalization view name	String	Double-click to access the Enter Normalization View dialog box. Type a normalization view name into the text box. See Configuring Normalization Views for more information. This parameter is required.
NormBeginT	Start date (C)	Date	Note: Used only in conjunction with End date (C) If used, double-click to access the Select Start Date dialog box. Select the starting date, in contract time (C), of the time range for which to update the normalization view. See Selecting Date and Time for more information. This parameter is optional.
NormEndT	End date (C)	Date	Note: Used only in conjunction with Start date (C) If used, double-click to access the Select End Date dialog box. Select the ending date, in contract time (C), of the time range for which to update the normalization view. See Selecting Date and Time for more information. This parameter is optional.
InclArch	Include archived data	String Enum	If used, double-click to access the Include Archived Data dialog box. Select one of the following options. Yes (YES via script) No (NO via script) If set to Yes archived records will also be accessed; expect a corresponding time delay for processing. If set to No only current records will be accessed. This parameter is optional.